title: Reverse the "natural order" of a MySQL table without ORDER BY?
body: <p>I'm dealing with a legacy database table that has no insertion date column or unique id column, however the natural order of insertion is still valid when examined with a simple <code>SELECT *</code> showing oldest to newest.</p>
  
  <p>I'd like like to fetch that data with pagination but reverse the order as if it was <code>ORDER BY date DESC</code></p>
  
  <p>I've thought about wrapping the query, assigning a numeric id to the resulting rows and then do an <code>ORDER BY</code> on the result but wow that seems crazy.</p>
  
  <p>Is there a more simple solution I am overlooking?</p>
  
  <p>I cannot add columns to the existing table, I have to work with it as is.</p>
  
  <p>Thanks for any ideas!</p>