WASHINGTON—Sen. Joe Manchin (D., W.Va.) and Senate Majority Leader Chuck Schumer (D., N.Y.) said they had agreed to a deal to support a legislative package that would spend hundreds of billions of dollars and affect a swath of climate, healthcare, prescription-drug and tax policies. The announcement …