You can use an identity field as mentioned or add a date column to your client briefcase - which you could then use for extra functionality like finding 'dead' briefcases or assessing briefcase take-up after a publicity drive.

SQL Server isn't a flat file system so there is no dirty way TIKO to assess the order that rows are added unless you use data like identity fields or date fields.