Code:
select max(sd_id) from final table
(insert into Sd_Source
select ifnull(max(sd_id), 0) + 1, 1, '000000500'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 2, '810400309'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 3, '065020000'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 4, '900500000'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 5, '704000813'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 6, '000007006'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 7, '000090030'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 8, '601004078'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
union all
select ifnull(max(sd_id), 0) + 1, 9, '008000000'
, ifnull(max(sd_id), 0) + 1, timestamp(generate_unique())
from Sd_Source
);