Meh. If your requirement is a single query, then you need to implement a linked list in the database. This isn't that hard, but it requires that all inserts and deletes update 3 rows vs. just selects doing three queries. This probably is ok.

CREATE TABLE images (
    id INT
   ,prev_id INT
   ,next_id INT
   ,other_columns_here
);
[download]

Then, to get everything in a single query, you do:

SELECT * FROM images WHERE ( (id=?) OR (next_id=?) OR (prev_id=?) );
[download]

Not that hard. :-)