Television presenter and physicist Prof Brian Cox has argued that boosting public funds to science would be a “sensible gamble”.