auto-incremento

I am passing the data from an old bank to a new bank. After executing all queries there were some primary key fields that w ... deleted. This occurs in several cases in the bank. How to completely delete the IDs and redo them to follow a correct order?

this question already has answers here : ... p that increments a letter in the received name ex: If the user enters precise letter B it turns it into a forward i.e. C.