Use a RECURSIVE CTE to list the numbers 1 through 5. Column: n. Ordered.

Answer

WITH RECURSIVE nums AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM nums WHERE n < 5 ) SELECT n FROM nums ORDER BY n;