with 
  tbl_1 as
 (select 1 as id, 1 as any_id from dual union all
  select 2, 1 from dual union all
  select 3, 3 from dual union all
  select 4, 2 from dual union all
  select 5, 2 from dual union all
  select 6, 2 from dual union all
  select 7, 6 from dual),
  tbl_2 as
 (select 1 as any_id, 100 as value from dual union all
  select 1, 150 from dual union all
  select 2, 250 from dual union all
  select 2, 250 from dual union all
  select 2, 260 from dual union all
  select 3, 325 from dual union all
  select 4, 444 from dual)
select t1.id, t1.any_id, t2.value from (select t1.*
,  row_number() OVER (partition by any_id order by id) as rn from tbl_1 t1) t1 
join (select t2.* ,  row_number() OVER (partition by any_id order by any_id) as rn from tbl_2 t2) t2 on t1.any_id = t2.any_id and t1.rn = t2.rn
order by t1.id