I know the fireworks can be seen in the sky in Limsa by looking toward the lighthouse.

Where can I see the fireworks in Ul'dah and Gridania?