As to what is used in professional orchestras - I am pretty sure this depends on the repertoire being played.
So I go to see the top London orchestras quite frequently and have seen international orchestras at the Proms - last time I saw Berlin and Chicago for example.
It's clear that in late romantic and 20th C, composers ask for specific instruments and groups of instruments.
So Mahler's Symphonies have a distinct sound, based on the instrumentation - like the 3rd has a prominent Tenor Horn part and the 7th has guitar and mandolin etc.
Mahler's 2nd symphony specifies the brass as follows :
10 Horns in F, four (7-10) used offstage
8-10 Trumpets in F and C, four to six used offstage
4 Trombones
Tuba
There are also many symphonic trumpet solos for very high-pitched parts and particular mutes etc. etc.
The top professional Orchestras I see, are clearly using a wide-range of trumpets and other brass instruments and that's without mentioning "period performances" !!
