insert into FooBar (ID, col1, col2, col3)
select ID, col1, col2, col3 from (
    select max(ID)+1 from FooBar) ID, 'a' col1, 1 col2, 'flort' col3
    union
    select max(ID)+1 from FooBar), 'b', 2, 'zap'
    union
    select max(ID)+1 from FooBar), 'c', 3, 'kazoo'
)