>It wouldn't work if you have more than 10 duplicate values or duplicates begin in the previous batch.
I know it, but the "order by" clause return me all records that have the same value in the search key, and it allows me work with this.
For example, if the query have 45 records with the same value in order field, the query return me all 45 records.