Optimize query

How would you optimize a query with greater than in where clause eg

select * from table1 where id > 1000 

and there is an index on id column

regards