You would limit by a start and finish point based on variables passed to the query.
When you give the query 2 variables
LIMIT 5, 10
would return row 6-15 from your results.
So to control the start point using a variable would be a simple matter of passing the STARTPOINT via a $_GET link
LIMIT $start, 10
So the first number is the offset of rows to return and the second is the maximum rows you want - in this case 10
Your link would look like