Yes– this is the primary use of SP Flash Tool. If the phone is completely off but detected by PC (via Device Manager as MediaTek USB Port), you can flash a full firmware and revive it.