title: Newbie in dilemma due to OCD tries to reorder SQL database automatically
body: <p>Sorry, I'm very new to SQL. I just learned it few hours ago. I'm using MariaDB + InnoDB Engine with HeidiSQL software + CodeIgniter 3. Let's say I have a table named <code>disciples</code> with the following data:</p>
  
  <pre><code> -------------------
  | sort_id | name    |
   -------------------
  |       1 | Peter   |
  |       4 | John    |
  |       3 | David   |
  |       5 | Petrus  |
  |       2 | Matthew |
   -------------------
  </code></pre>
  
  <p>I'm fully aware that it's better to have a column called <code>sort_id</code> to be able to fetch the data using <code>ORDER BY</code> if I prefer a custom sorting. But if I delete <code>row 3</code>, the new table will look like this:</p>
  
  <pre><code> -------------------
  | sort_id | name    |
   -------------------
  |       1 | Peter   |
  |       4 | John    |
  |       5 | Petrus  |
  |       2 | Matthew |
   -------------------
  </code></pre>
  
  <p>The thing is I'm having OCD (imagine there are 1000 rows), it hurts my eyes to see this mess with some missing numbers (in this case number 3 - see the above table) under <code>sort_id</code>. I think it has something to do with "relational database". Is there a way to quickly and automatically "re-assign/reset" new <code>sort_id</code> numbers to given rows and sort them <code>ASC order</code> according to the <code>name</code> <strong>using SQL code</strong> without having to do it manually?</p>
  
  <pre><code> -------------------
  | sort_id | name    |
   -------------------
  |       1 | John    |
  |       2 | Matthew |
  |       3 | Peter   |
  |       4 | Petrus  |
   -------------------
  </code></pre>