Six offshore workers were killed and another missing feared dead after a helicopter belonging to an Aberdeen-based firm ditched into the Irish Sea.