SET @row_number:=0;
INSERT INTO iden_nodes SELECT @row_number:=@row_number+1 AS node_id,id,name FROM identities
ORDER BY id;

id name
10 adam
11 sam
11 harry
12 josef

node_id  id  name
1        10  adam
2        11  sam
3        11  harry
4        12  josef

node_id   id    name
  1        10    adam
  1        11    sam
  2        11    harry
  1        12    josef