title: Adding order by with offset and limit in mysql query
body: <p>I have a mysql query</p>
  <pre><code>SELECT * FROM lead LIMIT 5 OFFSET 0 
  </code></pre>
  <p>to select data from the table lead and limit the results to 5 with offset of 0. I would like to order the results by its id by desc, so the results will be populated as the last added data first.</p>
  <p>I tried</p>
  <pre><code>SELECT * FROM lead LIMIT 5 OFFSET 0 order by id desc
  </code></pre>
  <p>but it's not working.  Please correct me where am wrong.</p>