title: Auto update unique id
body: <p>I have a table with a column 'id' which has auto_increment on. </p>
  
  <p>So for example when I add a new record it will assign it a number. </p>
  
  <p>But what I need is a way I can change the order of the records so for example there are 48 records in the db and I want record 29 to have the id of 5 instead of 29. So is there a way for record 29 to replace 5 and for them to all move up one so 5 would now be record 6 etc?</p>
  
  <p>Thanks!</p>