`alter` doesn't change the default value correctly with MSSQL

Issue Creation Checklist

• [ x] I have read the contribution guidelines

Bug Description

const { Model } = require('@sequelize/core');
module.exports = (sequelize, DataTypes) => {
  class SmsAccounts extends Model {
    static associate(models) {
    }
  }

  SmsAccounts.init(
    {
      expiresOn: {
        type: DataTypes.DATE,
        allowNull: false,
      },
      name: {
        type: DataTypes.STRING,
        allowNull: false,
      },
      portalId: {
        type: DataTypes.INTEGER,
        allowNull: false,
      },
      commodityClassification: {
        type: DataTypes.BOOLEAN,
        allowNull: false,
        defaultValue: false,
      },
      parentId: {
        type: DataTypes.INTEGER,
        allowNull: false,
      },
    },
    {
      sequelize,
      tableName: 'accounts',
      schema: process.env.SMS_SCHEMA,
      underscored: true,
    },
  );
  return SmsAccounts;
};

await sequelize.sync({ alter: true });

What do you expect to happen?

Update/create a table in mssql setting default values

What is actually happening?

Failing to set default value due to incorrect syntax.

Executing (default): ALTER TABLE [sms_test].[accounts] ALTER COLUMN [commodity_classification] BIT NOT NULL DEFAULT 0;
✖ Incorrect syntax near the keyword 'DEFAULT'.
✖ Error

Additional context

It should be doing something similar to the following

ALTER TABLE [sms_test].[accounts] ADD DEFAULT 0 FOR commodity_classification;

Environment

• Sequelize version: @sequelize/core@7.0.0-alpha.10 (Same is happening on sequelize@6.17.0)
• Node.js version: v17.8.0
• If TypeScript related: TypeScript version: N/A
• Database & Version: MSSQL (Microsoft SQL Azure (RTM) - 12.0.2000.8 )
• Connector library & Version: tedious (14.4.0)

Would you be willing to resolve this issue by submitting a Pull Request?

• [x ] No, I don't have the time, although I believe I could do it if I had the time...
  (Will try possibly next month once I've put out some fires.)

Start from the MSSQL SQL generated by sequelize.sync({ alter: true }) for the default value on commodity_classification. Compare the emitted ALTER COLUMN statement with the expected ADD DEFAULT syntax, then verify that MSSQL alter sync updates the default without a syntax error.