SQL> create table t as
  2  select t0.id, lpad('*', 4000, '*') padding from
  3  (
  4      select 'id1' id from dual union all
  5      select 'id2' id from dual union all
  6      select 'id3' id from dual union all
  7      select 'id4' id from dual
  8  ) t0;

Table created.

SQL> with list_val as (
  2      select * from t
  3  )
  4  select --+ parallel(2)
  5  id, rownum as rn, substr(id, -1) id_last from list_val;

ID          RN I
--- ---------- -
id2          1 2
id4          2 4
id3          3 3
id1          4 1