Code:
select max(sd_id) from final table
(insert into Sd_Source
select ifnull(max(sd_id), 0) + 1, 1, '700000009'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 2, '890060000'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 3, '010054020'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 4, '000298600'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 5, '007000000'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 6, '002375000'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 7, '050480030'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 8, '000010092'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 9, '600000007'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
);