title: mysql: specific item to be first and then to sort the rest chronologically to end then chronologically from beginning
body: <p>Lets say I have the following table: </p>
  
  <pre><code>friends
  _______
  
  id    name
  1     johnny
  2     tam
  3     slick
  4     mat
  5     Rhanda
  6     Tommy
  7     ike
  8     Spencer
  9     Alan
  </code></pre>
  
  <p>I want to get all the friends list but I want the id 5 to be the first item in the list. I want the next item to follow chronologically until the end. Then the list start from the beginning until all results have been returned. So it should end like this...</p>
  
  <pre><code>friends
  _______
  
  id    name
  5     Rhanda
  6     Tommy
  7     ike
  8     Spencer
  9     Alan
  1     johnny
  2     tam
  3     slick
  4     mat
  </code></pre>
  
  <p>I have found and tried this but as you can imagine it's only returning the first item and then ordering the rest from 1 up. I have searched and worked on this for 2 days now and really could use some help. Any suggestions? </p>