Almost always appears in the set phrases
翘首以待 or
翘首期盼 ("to eagerly look forward to") — a literary, slightly elevated way to express anticipation, common in news headlines about upcoming events.
翘 here is qiáo (2nd tone, "to lift up"), NOT qiào ("to stick up, to be exceptional").