A new bridge that will form a key part of the HS2 railway line has won an award for its good looks, with one design expert calling it 'breath-taking'.