It doesn't just occur in clouds; it can appear in clear air, in the ocean, and even in the atmosphere ... more likely to appear around sunrise or sunset, which is when lower clouds are cool ...
Waikiki came in at No. 1 for its "unobstructed ocean vistas and palm trees ... which include the "right amount of cloud cover, rainfall, and winds during sunset hours," which helped it gain ...