Donald Trump held the lowest public approval rating heading into a midterm election of any United States president since 1946