Remove trailing letters from a string in BigQuery SQL

I have ID values in a table that look like these:
ABC12345
AAZ54321
ZDA67890