Insert The Row In Middle Which Has Deleted From User If Table Has Primary Key ,and it Is Autoincrement

You probably shouldn't try. You can do it by disabling the auto-increment while you do it and resetting the info, then doing the insert and putting the increment parameters back then re-enabling it, but it really isn't a good idea, because the advantage of an auto-increment is that it is all handled for you. If you do, then you had better do it in a stored procedure, because SQL is a multi-user system and if anyone tries to create a new record while you have auto-increment disabled you whole system will fall apart.

If you want to order the rows, then use your own ordering system instead of letting SQL handle it and specify where you want records - don't try to use the same system for two different and unrelated purposes.