A survey of high‐frequency SiO masers in supergiants and AGB stars