title: Reset auto_increment after deleting row
body: <p>Hi i know this question has been asked before but i'm asking it differently, what i want is to reset the auto_increment column, after deleting a row in a table. if i have table with 51 rows and i delete row 48, i want row 49 to reset to 48,50 to 49 etc.</p>
  
  <p><img src="https://i.stack.imgur.com/Ajqeh.png" alt="enter image description here"></p>
  
  <p>i have tried using alter table but that insert data where the row was deleted, i want something that will shift the order.</p>
  
  <h2>    -- Table structure for table <code>torrents</code></h2>
  
  <pre><code>   CREATE TABLE IF NOT EXISTS `torrents` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `Title` varchar(250) NOT NULL,
    `Kat_Link` varchar(250) NOT NULL,
    `Tpb_Link` varchar(250) NOT NULL,
    `Lime_Link` varchar(250) NOT NULL,
    `ImgUrl` varchar(250) NOT NULL,
     PRIMARY KEY (`ID`)
     ) ENGINE=InnoDB;
  </code></pre>
  
  <p>what i want is to run a <code>select from table where ID = $id lmit 8</code> if the <code>ID</code> doesn't exists i get less than 8 rows.</p>