Posts with position > position of last known ID

gistfile1.sql

CREATE TABLE posts
	(
     id int primary key, 
     position int,
     animal text
    );

INSERT INTO posts
(id, position, animal)
VALUES
(1,1, 'alpaca'),
(2,2, 'bird'),
(3,3, 'cow');

SELECT * from posts
JOIN posts AS last
ON posts.id = last.id
AND last.id = 2
WHERE posts.position > last.position
ORDER BY posts.position;