id, link_id, ....

123, 98,   ...
98,  74,   ...
74,  32,   ...
32,  null, ...

with recursive
  history as (
    select id, val, link_id from odata where link_id is null
    union all
    select o.id, o.val, o.link_id from odata o
      join history h on h.id = o.link_id)
select id, val, link_id from history;