It came out in 1999, and was an individual option ($60) on 1999 and 2000 coupes/verts.
In 2001 and later years. it wasn't individually available, but was included in the 1SC option pkg for coupes/verts.
As best I can tell, it was not available at all on FRC and Z06s. Although it might on Canadian export versions, as the feature was standard and not defeatable on those export cars. (can't toggle it off in the DIC options).
My 2001 has it, but I have the feature turned off. Mainly because I like to run with just the fog lights on when it's not totally dark out. That, and having the lights flip up just pulling into the garage is a bit annoying too.