Note that selecting the 2000th post by postid will ignore gaps in the postid values. Gaps are created when posts are deleted.
This query will select the 2000th post record of the posts that currently exist:
Code:
SELECT *
FROM xf_post
ORDER BY post_id
ASC
LIMIT 1999, 1
One method is not more correct than the other. It just depends on how you want to identify the 2000th post.