Ordreing by previous foreign key

WITH RECURSIVE recursetree(id) AS (
    SELECT id, prev_elem FROM table_name WHERE prev_elem IS NULL
    UNION ALL
    SELECT t.id, t.prev_elem
    FROM table_name t
    JOIN recursetree rt ON rt.id = t.prev_elem
)
SELECT id, prev_elem FROM recursetree;