Dump Particular range of values from table in Sql

Here is simple sql to dump particular range of values into a sql file

SELECT * FROM anagram LIMIT 1001, 10000 INTO OUTFILE '/opt/lampp/htdocs/test/teest.sql'

will result a file named teest.sql in the given path with values from 1001 to 10000 from table anagram