A new survey has shown that the majority of American people oppose a military conflict with Iran amid heightened tensions between the two countries.