Hundreds of offshore workers could be at risk of losing their jobs when a new weight limit comes into effect next month, an industry body has warned.