title: sqlite order by after limit offset
body: <p>So I can <a href="https://stackoverflow.com/a/3325580/4769440">paginate a query</a> with <code>LIMIT</code> and <code>OFFSET</code></p>
  
  <pre><code>SELECT * 
  FROM db.table
  LIMIT 6
  OFFSET 0
  </code></pre>
  
  <p>But if I try to <code>ORDER BY</code> this result I get the first <code>n</code> ordered rows, not the first <code>n</code> rows ordered.</p>
  
  <pre><code>SELECT * 
  FROM db.table
  LIMIT 6
  OFFSET 0
  ORDER BY first_name COLLATE NOCASE
  </code></pre>
  
  <p>So instead of</p>
  
  <pre><code>bob
  charles
  dave
  dan
  doug
  durrand
  </code></pre>
  
  <p>I want to get</p>
  
  <pre><code>bob
  doug
  elliot
  manny
  ralph
  xavier
  </code></pre>