SQL. How to "find out the next" line?

Question

PHP

Look, there is a "files" table. For example, it has 2 fields: id (auto-increment) and name.
For example, the user is looking at a file with id - 2. I need to implement the "Next File" and "Previous File" buttons.
But I don't know how to do this, since over time id can be scattered (for example, the file was deleted).

Answer 1

Next - SELECT * FROM FILES WHERE ID > '2' ORDER BY ID LIMIT 1
previous SELECT * FROM FILES WHERE ID < '2' ORDER BY ID LIMIT 1