title: How to shift rows in Laravel Eloquent?
body: <p>I have a table like this:</p>
  
  <pre><code>+--------+-------------------+-----------+
  | ID     | Type              |  Order    |
  +--------+-------------------+-----------+
  | 1      | A                 | 0         |
  | 2      | A                 | 1         |
  | 3      | A                 | 2         |
  | 4      | B                 | 0         |
  | 5      | B                 | 1         |
  | 6      | B                 | 2         |
  | 7      | B                 | 3         |
  | 8      | B                 | 4         |
  | 9      | C                 | 0         |
  | 10     | C                 | 1         |
  +--------+-------------------+-----------+
  </code></pre>
  
  <p>Using Laravel Eloquent:</p>
  
  <pre><code>$list = Type::where('Type', '=', 'B')
      -&gt;where('Order', '=', '2');
  
  $list-&gt;delete();
  </code></pre>
  
  <p>If I do the above, I get the following:</p>
  
  <pre><code>+--------+-------------------+-----------+
  | ID     | Type              |  Order    |
  +--------+-------------------+-----------+
  | 1      | A                 | 0         |
  | 2      | A                 | 1         |
  | 3      | A                 | 2         |
  | 4      | B                 | 0         |
  | 5      | B                 | 1         |
  | 7      | B                 | 3         | &lt;- notice the Order 2 row is gone
  | 8      | B                 | 4         |
  | 9      | C                 | 0         |
  | 10     | C                 | 1         |
  +--------+-------------------+-----------+
  </code></pre>
  
  <p>How can I make it so the Order shifts accordingly for Type B, so it looks like this?</p>
  
  <pre><code>+--------+-------------------+-----------+
  | ID     | Type              |  Order    |
  +--------+-------------------+-----------+
  | 1      | A                 | 0         |
  | 2      | A                 | 1         |
  | 3      | A                 | 2         |
  | 4      | B                 | 0         |
  | 5      | B                 | 1         |
  | 7      | B                 | 2         |
  | 8      | B                 | 3         |
  | 9      | C                 | 0         |
  | 10     | C                 | 1         |
  +--------+-------------------+-----------+
  </code></pre>