Exercise can be as good a medicine as pills for people with conditions such as heart disease, a study has found.