How to get the records from database order by a column

How to get the records from database order by a column

I have a 50k records are stored in my mysql database. I have to insert 1k
records into excel.
So, I am querying the records using limit 0, 1000 and limit 1000, 1000
like this. I have to get records using order by of a particular column. I
can do this by queryinng using order by.
But if I have same order by of a particular column records from 990 to
1030 because of this limit 0, 1000 function these are splitting. but I
want to get all order by values into same excel. If limit is increased or
decreased by 50 or 100 records it is ok for me.