Do patients have worse outcomes in heart failure than in cancer? A primary care‐based cohort study with 10‐year follow‐up in Scotland