'Amazing' rare waterspout seen over Bristol Channel