I still don’t understand how you got into this state, the only place we fiddle with this is when you move posts.
Post creator simply sets sort_order to post_number
Long term I am not even sure I want to carry sort_order column, it appears to be a footgun of sorts.
Are there any plugins involved here?