The database is not just storing the posts that you have created, it stores revisions of that post along with other post types, etc. all in this table. So the post ids of the posts that we enter rarely go up one at a time.
The post ids themselves are not very relevant in the queries. The specific queries are used to only show posts that have a certain criteria, such as category, post_type, date stored, etc.