The C trumpet is used in orchestras and brass choirs.  Many soloists choose the C trumpet for its agility and clear, centered toner.  You can also read concert pitch parts with no transposition necessary.  If you have a Bb trumpet and wish to branch out toward more classical playing, mastery of a C trumpet should be your next conquest.