Just use math:


SELECT whatever_columns FROM whatever_table WHERE my_id=previous_id+1;