Without ORDER BY, a database returns rows in whatever order is quickest for it, and that order can change. When order matters, say so:
SELECT name, price
FROM products
ORDER BY price DESC;
ASC (smallest first, A to Z, oldest date first) is the default; DESC reverses it. Sort by several columns with commas: ORDER BY category, price DESC sorts by category, then by price within each category.
LIMIT keeps only the first rows of the result, so ORDER BY ... DESC LIMIT 5 gives you a top five. OFFSET skips rows first: LIMIT 1 OFFSET 1 returns the second row. SQL Server writes this as SELECT TOP 5 or OFFSET ... FETCH; PostgreSQL, MySQL, SQLite and most test platforms use LIMIT.
The clauses always come in this order: SELECT, FROM, WHERE, ORDER BY, LIMIT.