How to add an automatically-populated custom sequence number?
Create a trigger that on INSERT will populate that filed. 

You cannot have it as a calculated column, as latter cannot refer to any tables.