title: H2 limit and offset, is there a guarantee on ordering?
body: <p>When using LIMIT and OFFSET, what are the guarantees that each such statement will order the input in the same way?
  To illustrate:</p>
  
  <pre>
   *price* | *product*
  ---------------------
    2.99   | party hat green
    2.99   | party hat pink
    3.99   | red ball
    3.99   | blue ball
    3.99   | yellow ball
  </pre>
  
  <p>If:</p>
  
  <pre><code>SELECT FROM toys ORDER BY price ASC LIMIT 3;
  </code></pre>
  
  <p>returns:</p>
  
  <pre>
   *price* | *product*
  ---------------------
    2.99   | party hat green
    2.99   | party hat pink
    3.99   | red ball
  </pre>
  
  <p>Can i be sure the next query: </p>
  
  <pre><code>SELECT FROM toys ORDER BY price ASC LIMIT 3 OFFSET 3;
  </code></pre>
  
  <p>returns: </p>
  
  <pre>
   *price* | *product*
  ---------------------
    3.99   | blue ball
    3.99   | yellow ball
  </pre>
  
  <p>After all, all three balls have the same price, so any ordering of the three rows is valid.</p>