Substance misuse and psychiatric illness: prospective observational study using the general practice research database