SQL: Delete all but last items in groups of elements (grouped by common field) and incremental identifier

query.sql

DELETE FROM
    blah
WHERE
    id NOT IN (
        SELECT
            c.id
        FROM
            blah c
        LEFT JOIN 
            blah d
            ON (
                c.common_field = d.common_field
                AND c.id < d.id
            )
        WHERE
            d.id IS NUL 
    )