Creating an auto incrementing column in Firebird

or in any database that supports triggers and generators (aka sequences)
The answer is well known however the question comes out quite often, be it in an Oracle, Firebird or PostgreSQL forum