Sort list of Records by the order they were created in

Hmm my only thoughts to do this would be through a Formula or an Automation.

Airtable already has the data you're looking for built into each record. A formula is just pulling that data out. An Automation would create new data on top of your records that you could then use to stipulate created time.

I'd recommend a formula like the "Created Time" field as a solution. You could even use the "Autonumber" field and sort that. However, it seem that isn't a viable option for you.

Automations would be able to do what you're looking for but would take many automation runs. For the automation, you could either copy the time from a created time field, into a regular date field. Or use a script to collect the current time and paste that step into a regular date field.

Here's a script to find the current time:

var dt = new Date();
output.set('nowTimestamp', dt.toISOString());