Effective string picture for confinement at finite temperature: Theoretical predictions and high precision numerical results