Liam Payne was 'visibly out of his mind' when he went down to the hotel lobby in the moments leading up to his tragic death