A Republican-led bill seeking to ban trans athletes from women’s sport failed to gain the required votes in the US Senate.