Queen guitarist Brian May had the full support of his fans as he posted an emotional tribute to his late friend