SQL insert question

How do you use SQL insert to insert the correctly sequenced Primary ID to a table row?