A chorus of “he was the last of his kind” was ringing out across social media upon news of the music legend’s death on Friday