Moving IDs in SQL

After searching google and forums I cant find this solution.

I want to insert an Id where one exists but instead of swapping its going to have to ++ to the rest of the ids in front of it? I’m assuming this will be done with a loop? Or because its auto increment it will automatically know to move everything up?