MYSQL start at nth result (opposite of LIMIT)

Question

Is there a SQL command for starting at a certain amount of results? Example:

SELECT * FROM table WHERE ID=1 BEGIN AT 100

Answer 1

SELECT * FROM table WHERE ID=1 LIMIT 100,500;

result will show 500 value from 100