It's no secret that Riker's character was supposed to be the lady's man in the Next Generation. Where Picard was sensible, Riker was his complimentary foil. His character developed over the years to be much more sensible so first and second season were really the only times I can remember where we got to see sexy Riker. Besides by the end I just wanted him and Deanna Troi to get together already!
Can you imagine him in this little number by the end of series run? I think not. But how nice it was to see it then. Make it so, Number One!