Physical condition of the molecular gas at the centre of NGC 1097