Can the previous and next record be appropriately chosen using the ID of the current record?

edit

Yes, it is possible to choose the previous and next record using the ID of the current record. The previous record can be selected by finding the largest ID that is less than the ID of the current record, while the next record can be found by selecting the smallest ID that is greater than the ID of the current record. This approach assumes that the ID values are unique and sequential.