The qiáo reading is literary and bound to set expressions — don't try to use it as a free word. The two you'll meet most often are
翘首 (to crane one's neck, look up expectantly) and
翘楚 (the standout in a field). Both retain a refined, classical flavor.