Can hydrogen production align with Net Zero? A systematic analysis of onshore and offshore production pathways