SQL ascending and descending

"Select top 10 * from items ":

What does this mean? Is it equal to 1-10 records? The answer is "false", because top only queries the first 10 records in the data table. In general, top 10 records are arranged in order from 1 to 10, but sometimes it is not arranged in the order of search? Top 10 at this time

What may happen is:

ID name
1 aaa
2 bbb
5 CCCC
.
.
.

N ...... From the above, it is not necessarily from 1 to 10, and the ID is 3 or 4. It does not exist. It may be after 10th.

What if we want to follow the first 10 items from small to large: here we use the Ascending Order (ASC)

Use: Select top 10 * from items order by id asc. In this way, we can obtain records from 1 to 10.

Get new 10: Select top 10 * from items order by ID DESC