I have to ask why order matters for the records stored in the table. SQL Server makes no guarantee about that. The only reliable way I am aware of to present records in a desired sequence is to use an order by clause when you select the records. I would never rely on the storage order of data in a SQL Server table.

This behavior is different in the AS400 world, where you can present data in arrival order, and influence that order with an order by in the table load process.