Alternate to sequence

[kaji Pasa]

I created a table with id as auto increment
create table JUNK_1(
id int not null auto_increment,
standartTitle varchar(4000),
title varchar(4000),
SSID varchar(4000),
title_id int(11),
`Database` varchar(255),
databaseid varchar(255),
provider varchar(255),
providerid varchar(255),
CONSTRAINT ID_PK PRIMARY KEY (ID)
);

Now i want to populate this table with record from other table but id should be sequential like 1,2... and rest of the columns from other table


INSERT into junk_1
select standardtitle,title,ssid,title_id,`database`,databaseid,provider,providerid from holdings_parts_jeff;
As we dont have sequence in mysql, how do i use the sequential id during the insert in junk_1 table