Group-theoretical classification of multipole order: Emergent responses and candidate materials