>It's quite easy. You generate the primary key (a guid) on the client/web server, not on the database server. You have the order number as auto incrementing. You save the record, and requery it using the generated primary key.
How can you show the number on the form when you're working on the order? You still should have an ability to Cancel.
If it's not broken, fix it until it is.
My Blog