title: Get the next row from a query
body: <p>I've got these data in the DB:</p>
  
  <pre><code>ID    col1    col2
  32      2      0
  31      2      0
  76      1      0
  12      0      0
  10      0      0
  25      0      1
  20      0      1
  28      0      2
  </code></pre>
  
  <p>These data has been obtained from this query:</p>
  
  <pre><code>SELECT ID, col1, col2 
  FROM tableA
  ORDER BY col1 DESC, col2 ASC, ID DESC
  </code></pre>
  
  <p>Once I have and ID/col1 value, I would like to get the next row of this query.
  Could it be possible to do it with an only query?</p>
  
  <p>Important information: col1 and col2 can't be both different to zero. If col1 is different to zero, col2 is zero and vice versa.</p>
  
  <p>EDIT:
  I'm using MySQL. No API's</p>
  
  <p>Let's say, for example that I have ID: 31. Then I need to get the row with ID 76 </p>
  
  <p>If I have the ID 10, then I need the row with ID 25.</p>