SELECT TOP 1 * from (SELECT TOP 2 * from tabella ORDER BY id DESC) ORDER BY id ASC

ed hai il penultimo