The ‘As Tears Go By’ singer has died at the age of 78