ok.

per quelle dopo

SELECT TOP 3 colonne FROM tabella WHERE ID>tuo_id ORDER BY ID

per quelle prima

SELECT TOP 3 colonne FROM
(SELECT colonne FROM tabella WHERE ID<tuo_id ORDER BY ID DESC)
ORDER BY ID